HJoin Tables pairwise¶
Horizontal join of two Tables
Documentation
Auto generated list version of HJoin Table.
In this version, the following ports from the original nodes have been changed to lists which the node loops over:
- Looped Inputs
port1, port2.
- Looped Outputs
port1.
For details see the original node.
Definition
Input ports
- port1
1 - 1, [table]
Input Table
- port2
1 - inf, [table]
Input Table
Output ports
- port1
[table]
Table with horizontally joined data
- Configuration:
- Complement missing rows (mask)
Select if rows that are not represented in all Tables should be complemented with masked values
- Rename duplicate columns (rename)
If true columns with same name as an earlier column will be renamed and joined, otherwise columns will overwrite existing data
- Input port name for joined table (name)
Select which port decides the output table(s) names
The operation of horizontal join, or HJoin, stacks the columns in the incoming Tables horizontally beside each other. The outgoing Table will have all the columns from all the incoming Tables.
If the setting ‘Complement missing rows’ is false then all Tables that should be joined must have the same number of rows. Otherwise, Tables with different number of rows are padded with masked values.
If a column name exists in both inputs the latter Table (or lower port) will take precedence and the corresponding column from the former Table (or upper port) will be lost.
The node always tries to give the output table a name, so if the chosen port has a table without name, the other port will be used. This is to preserve backwards compatibility.
Related nodes
Example flows
